CDISC Builder™  2.1 - Installation Test Scripts - %metadata
The following documentation contains test scripts and expected results for validating the CDISC Builder tool.  Do the following to verify proper installation:
  • Start CDISC Builder application by double clicking on the desktop icon.
  • Perform each test by performing the steps specified by the instructions.  
  • Evaluate the results of each step by comparing them with results described in the Documentation column. 
Script Description Documentation
metadata1.sas Verify for missing required field source.  Instructions 1
metadata1.log
metadata2.sas Verify the invalid of parameters:
  1. source - invalid libname and/or dataset.
  2. metadb - invalid libname or dataset.
  3. search - under 20 characters
  4. task - has the two valid values.
  5. output - invalid path or if file is specified, it is either an HTML extension.
 Instructions 2
metadata2.log
metadata3.sas Verify that import captures all attributes of the dataset and associated variables. Instructions 3
metadata3.log
metadata4.sas Verify updates to existing specified metadata database. Instructions 4
metadata4.log
metadata5.sas Verify the deletion of metadata for specified data. Instructions 5
metadata5.log
metadata6.sas Verify the search results from search criteria with special characters.  Instructions 6
metadata6.log
metadata7.sas Verify the output report contains all the attributes including hyperlinks from data to detail variable attributes. Instructions 7
 metadata7.log
metadata8.sas Verify default behavior of all parameters. Instructions 8
 metadata8.log
metadata9.sas Verify the sample template code generated matches with the attribute in the output report. Instructions 9
metadata9.log

Instructions 1
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the metadata1.sas program and select "Batch Submit".

  3. Verify that it generates the file:metadata1.log.

  4. Open the metadata1.log. Verify that there will be an error message as follow.

    ERROR: [metadata] is missing required parameter SOURCE.

Instructions 2
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the metadata2.sas program and select "Batch Submit".

  3. Verify that it generates the file:metadata2.log.

  4. Open the metadata2.log. Verify that there will be error messages as follow.

    ERROR: [metadata] has an invalid source specified by SOURCE. 

    ERROR: [metadata] has an invalid source specified by SOURCE. 

    ERROR: [metadata] has an invalid metadata database specified by METADB.

    ERROR: [metadata] has an invalid text search criteria which is longer than 20 characters.

    ERROR: [metadata] has an invalid task specified by TASK. 

    ERROR: [metadata] has an invalid path specified by OUTPUT: Z:\notexist\dontknow.

    ERROR: [metadata] has an invalid path specified by OUTPUT: C:\metadb.txt.

Instructions 3
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the metadata3.sas program and select "Batch Submit".

  3. Verify that it generates the file: metadata3.log. Verify there's no  error message.

  4. Verify there is a 'metadb.sas7bdat' created follow the path such as "C:temp\testing\data\metadata".

Instructions 4
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the output directory named 'C:\temp\testing\data\metadata'.

  2. Ensure the metadb.sas7bdat that we created in the Instruction 3 is exists.

  3. Open metadb.sas7bdat and verify there are containing 17 rows. Close metadb.sas7bdat.

  4. Navigate to the validation sub-directory named "saspgm".

  5. Right mouse click on the metadata4.sas program and select "Batch Submit".

  6. Verify that it generates the file: metadata4.log. Verify there's no  error message.

  7. Navigate to the output directory named 'C:\temp\testing\data\metadata'.

  8. Open metadb.sas7bdat and verify there are containing 24 rows.

Instructions 5
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the output directory named 'C:\temp\testing\data\metadata'.

  2. Ensure the metadb.sas7bdat exists.

  3. Open metadb.sas7bdat and verify there are 'ELIG' values in memname column. Close metadb.sas7bdat.

  4. Navigate to the validation sub-directory named "saspgm".

  5. Right mouse click on the metadata5.sas program and select "Batch Submit".

  6. Verify that it generates the file: metadata5.log. Verify there's no  error message.

  7. Navigate to the output directory named 'C:\temp\testing\data\metadata'.

  8. Open metadb.sas7bdat and verify there is no 'ELIG' value in memname column.

Instructions 6
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the metadata6.sas program and select "Batch Submit".

  3. Verify that it generates the file: metadata6.log. Verify there's no  error message.

  4. Verify there's a metadata_search.html created.

  5. Open metadata_search.html and verify there is 'a note as the following:

    Your search - '!@#$%^&*()' - did not match any documents.

Instructions 7
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the metadata7.sas program and select "Batch Submit".

  3. Verify that it generates the file:metadata7.log. Verify there's no  error message.

  4. Verify there's a metadata_search.html created.

  5. Open metadata_search.html and verify that click on 'details' hyperlink to link detail variable attributes.

Instructions 8
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the metadata8.sas program and select "Batch Submit".

  3. Verify that it generates the file:metadata8.log. Verify there's no  error message.

  4. Verify there is metadata_search.html created.

Instructions 9
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation sub-directory named "saspgm".

  2. Right mouse click on the metadata9.sas program and select "Batch Submit".

  3. Verify that it generates the file:metadata9.log. Verify there's no  error message.

  4. Verify there will be a 'metadata_search.html' created in 'C:\temp\cdiscbuilder'.

  5. Open 'metadata_search.html' and verify there is a sample code at the bottom of file.

For more information, please contact MXI .

 
     Meta-Xceed Inc. © 2009